<%--
  Created by IntelliJ IDEA.
  User: Albert Lee
  Date: 2020/5/26
  Time: 16:37
  To change this template use File | Settings | File Templates.
--%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ page import="java.sql.*"%>

<%

    String path = request.getContextPath();

    String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

%>

 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

  <head>

              <base href="<%=basePath%>">

              

              <title>插入学生信息</title>

              

    <meta http-equiv="pragma" content="no-cache">

    <meta http-equiv="cache-control" content="no-cache">

    <meta http-equiv="expires" content="0">    

    <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">

    <meta http-equiv="description" content="This is my page">

    <!--

    <link rel="stylesheet" type="text/css" href="styles.css">

    -->

     

      </head>

    <body background="pic/background.jpg">

    <%

              request.setCharacterEncoding("UTF-8");

              String id = request.getParameter("id");

              String name = request.getParameter("name");

              System.out.println(name);

              String age = request.getParameter("age");

              String gender = request.getParameter("gender");

              String major = request.getParameter("major");

              Connection conn = null;

              Statement stat = null;

              ResultSet rs = null;

              Class.forName("com.mysql.cj.jdbc.Driver");

              String url = "jdbc:mysql://localhost:3306/student";

              String user = "root";

              String password = "123456";

              conn = DriverManager.getConnection(url, user, password);

              stat = conn.createStatement();

              String sql = "insert into stu(id,name,age,gender,major) values(" + id + ",'" + name + "'," + age + ",'" + gender + "','" + major + "')";

              stat.executeUpdate(sql);

              rs = stat.executeQuery("select * from stu");

%>

   

   <center>

       <%

              if(rs.next())

              {

              out.print("<br><h3>成功输入！</h3>");

              }

              else{

              out.print("<br><h3>输入失败！</h3>");

              }

              %>

                <br>
                <br>
              <a href=addStuInfo.jsp>返回添加信息页面</a>   <a href=showInfo.jsp>进入信息查询页面</a>

              </center>

     <%

              if(rs != null)

              {

              rs.close();

              rs = null;

              }

              if(stat != null)

              {

              stat.close();

              stat = null;

              }

              if(conn != null)

              {

              conn.close();

              conn = null;

              }

              %>     

      </body>

</html>
